import openpyxl
file = openpyxl.open('./dede_shops_products.xlsx')
sheet = file.active
cols = sheet['A']
for i in cols :
    if i.value=="989遗传学" :
        print(sheet['B'+str(i.row)].value,sheet['C'+str(i.row)].value,sheet['D'+str(i.row)].value)

        if sheet['B' + str(i.row)].value == 'S-P1415076825RN261':
            print('找到了')

